package com.locatme.modelBD;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


public class BdLocatme extends SQLiteOpenHelper {

    //nom et version de la base de donnée
    private static final String NOM_BDD = "locatme.sqlite";
    private static final int VERSION_BDD = 36;

    //=========================================Table TypeEtablissement=====================================//
    public static final String TABLE_TYPE_ETAB = "TypeEtablissement";
    public static final String COL_ID_TYPE = "id_type";
    public static final String COL_TYPE = "type";

    //Creation table TypeEtab
    private static final String CREATE_TABLE_TYPE_ETAB = "CREATE TABLE IF NOT EXISTS " + TABLE_TYPE_ETAB +
            "(" + COL_ID_TYPE + " INTEGER PRIMARY KEY AUTOINCREMENT," +
            COL_TYPE + " TEXT NOT NULL);";

    //Suppression table TypeEtab
    private static final String DROP_TABLE_TYPE_ETAB = "DROP TABLE IF EXISTS " + TABLE_TYPE_ETAB + ";";

    //=======================================Table Localisation================================//
    public static final String TABLE_LOCALISATION = "Localisation";
    public static final String COL_ID_LOC = "id_loc";
    public static final String COL_LATITUDE = "latitude";
    public static final String COL_LONGITUDE = "longitude";

    //Creation table Localisation
    private static final String CREATE_TABLE_LOCALISATION = "CREATE TABLE IF NOT EXISTS " + TABLE_LOCALISATION +
            "(" + COL_ID_LOC + " INTEGER PRIMARY KEY AUTOINCREMENT," +
            COL_LATITUDE + " NUMERIC ," + COL_LONGITUDE + " NUMERIC);";

    //Suppression table Localisation
    private static final String DROP_TABLE_LOCALISATION = "DROP TABLE IF EXISTS " + TABLE_LOCALISATION + ";";

    //============================================Table Note=============================================//
    public static final String TABLE_NOTE = "Note";
    public static final String COL_ID_NOTE = "id_note";
    public static final String COL_NOTE = "note";
    public static final String COL_NB_VOTE = "nb_vote";

    //Creation table Note
    private static final String CREATE_TABLE_NOTE = "CREATE TABLE IF NOT EXISTS " + TABLE_NOTE +
            "(" + COL_ID_NOTE + " INTEGER PRIMARY KEY AUTOINCREMENT," + COL_NOTE + " FLOAT NOT NULL ," + COL_NB_VOTE + " INTEGER);";

    //Suppression table Note
    private static final String DROP_TABLE_NOTE = "DROP TABLE IF EXISTS " + TABLE_NOTE + ";";

    //==============================================Table Enseigne===============================//
    public static final String TABLE_ENSEIGNE = "Enseigne";
    public static final String COL_LOGIN_ENSEIGNE = "login_enseigne";
    public static final String COL_PWD_Enseigne = "pwd_enseigne";
    public static final String COL_ID_NOTE_E = "id_note";
    public static final String COL_NOM_ENSEIGNE = "nom_enseigne";
    public static final String COL_DESC_ENSEIGNE = "desc_enseigne";
    public static final String COL_TEL_ENSEIGNE = "tel_enseigne";
    public static final String COL_ID_TYPE_ENSEIGNE = "id_type";
    public static final String COL_H_OUVERTURE = "heure_ouverture";
    public static final String COL_H_FERMETURE = "heure_fermeture";
    public static final String COL_ID_LOC_E = "id_loc";

    //Creation table Enseigne
    private static final String CREATE_TABLE_ENSEIGNE = "CREATE TABLE IF NOT EXISTS " + TABLE_ENSEIGNE +
            "(" + COL_LOGIN_ENSEIGNE + " TEXT PRIMARY KEY NOT NULL," + COL_PWD_Enseigne + " TEXT NOT NULL," +
            COL_DESC_ENSEIGNE + " TEXT," + COL_TEL_ENSEIGNE + " TEXT," + COL_ID_TYPE_ENSEIGNE + " INTEGER," + COL_NOM_ENSEIGNE + " TEXT," +
            COL_ID_NOTE_E + " INTEGER," + COL_H_OUVERTURE + " TEXT ," + COL_H_FERMETURE + " TEXT," + COL_ID_LOC_E + " INTEGER," +
            "FOREIGN KEY (" + COL_ID_TYPE_ENSEIGNE + ") REFERENCES " + TABLE_TYPE_ETAB + "(" + COL_ID_TYPE + ")" +
            "FOREIGN KEY (" + COL_ID_LOC_E + ") REFERENCES " + TABLE_LOCALISATION + "(" + COL_ID_LOC + ")," +
            "FOREIGN KEY (" + COL_ID_NOTE_E + ") REFERENCES " + TABLE_NOTE + "(" + COL_ID_NOTE + "));";

    //Suppression table Enseigne
    private static final String DROP_TABLE_ENSEIGNE = "DROP TABLE IF EXISTS " + TABLE_ENSEIGNE + ";";

    //============================================Table Personne===============================//
    public static final String TABLE_PERSONNE = "Personne";
    public static final String COL_LOGIN_PERSONNE = "login_personne";
    public static final String COL_PWD_PERSONNE = "pwd_personne";
    public static final String COL_NOM_P = "nom_p";
    public static final String COL_PRENOM_P = "prenom_p";
    public static final String COL_TEL_P = "tel_p";
    public static final String COL_PSEUDO = "pseudo";
    public static final String COL_ID_NOTE_P = "id_note";
    public static final String COL_ID_LOC_P = "id_loc";

    //Creation table Personne
    private static final String CREATE_TABLE_PERSONNE = "CREATE TABLE IF NOT EXISTS " + TABLE_PERSONNE +
            "(" + COL_LOGIN_PERSONNE + " TEXT PRIMARY KEY NOT NULL," + COL_PWD_PERSONNE + " TEXT NOT NULL," +
            COL_NOM_P + " TEXT," + COL_PRENOM_P + " TEXT," + COL_TEL_P + " TEXT," + COL_ID_NOTE_P + " INTEGER," + COL_ID_LOC_P + " INTEGER," +
            COL_PSEUDO + " TEXT," +
            "FOREIGN KEY (" + COL_ID_LOC_P + ") REFERENCES " + TABLE_LOCALISATION + "(" + COL_ID_LOC + ")," +
            "FOREIGN KEY (" + COL_ID_NOTE_P + ") REFERENCES " + TABLE_NOTE + "(" + COL_ID_NOTE + "));";

    //Suppression table Personne
    private static final String DROP_TABLE_PERSONNE = "DROP TABLE IF EXISTS " + TABLE_PERSONNE + ";";

    //============================================Table Langue================================//
    public static final String TABLE_LANGUE = "Langue";
    public static final String COL_ID_LANGUE = "id_langue";
    public static final String COL_NOM_LANGUE = "nom_langue";

    //Creation table Langue
    private static final String CREATE_TABLE_LANGUE = "CREATE TABLE IF NOT EXISTS " + TABLE_LANGUE +
            "(" + COL_ID_LANGUE + " INTEGER PRIMARY KEY AUTOINCREMENT," +
            COL_NOM_LANGUE + " TEXT NOT NULL);";

    //Suppression table Langue
    private static final String DROP_TABLE_LANGUE = "DROP TABLE IF EXISTS " + TABLE_LANGUE + ";";


    //========================================Table Commentaire================================//
    public static final String TABLE_COMMENTAIRE = "Commentaire";
    public static final String COL_ID_COMMENTAIRE = "id_commentaire";
    public static final String COL_COMMENTAIRE = "commentaire";
    public static final String COL_LOGIN_P = "login_personne";
    public static final String COL_LOGIN_E = "login_enseigne";

    //Creation table Commentaire
    private static final String CREATE_TABLE_COMMENTAIRE = "CREATE TABLE IF NOT EXISTS " + TABLE_COMMENTAIRE +
            "(" + COL_ID_COMMENTAIRE + " INTEGER PRIMARY KEY AUTOINCREMENT," +
            COL_COMMENTAIRE + " TEXT NOT NULL," + COL_LOGIN_P + " TEXT NOT NULL," + COL_LOGIN_E + " TEXT NOT NULL," +
            "FOREIGN KEY (" + COL_LOGIN_P + ") REFERENCES " + TABLE_PERSONNE + "(" + COL_LOGIN_PERSONNE + ")" +
            "FOREIGN KEY (" + COL_LOGIN_E + ") REFERENCES " + TABLE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE + "));";

    //Suppression table Commentaire
    private static final String DROP_TABLE_COMMENTAIRE = "DROP TABLE IF EXISTS " + TABLE_COMMENTAIRE + ";";


    //=======================================Table Message=====================================//
    public static final String TABLE_MESSAGE = "Message";
    public static final String COL_ID_MESSAGE = "id_message";
    public static final String COL_OBJET_MESSAGE = "objet_message";
    public static final String COL_MESSAGE = "txtmessage";
    public static final String COL_DATE_MESSAGE = "date_message";
    public static final String COL_LOGIN_EMETTEUR = "login_emet";
    public static final String COL_LOGIN_RECEPTEUR = "login_recept";
    //Creation table Message
    private static final String CREATE_TABLE_MESSAGE = "CREATE TABLE IF NOT EXISTS " + TABLE_MESSAGE +
            "(" + COL_ID_MESSAGE + " INTEGER PRIMARY KEY AUTOINCREMENT," + COL_OBJET_MESSAGE + " TEXT," +
            COL_MESSAGE + " TEXT NOT NULL," + COL_DATE_MESSAGE + " TEXT,"
            + COL_LOGIN_EMETTEUR + " TEXT NOT NULL," + COL_LOGIN_RECEPTEUR + " TEXT NOT NULL);";

    //Suppression table Message
    private static final String DROP_TABLE_MESSAGE = "DROP TABLE IF EXISTS " + TABLE_MESSAGE + ";";


    //===============================Table association entre personne et langue============================//
    public static final String TABLE_LANGUE_PERSONNE = "LanguePersonne";
    public static final String COL_LOGIN_PERSONNE_LP = "login_personne";
    public static final String COL_ID_LANGUE_LU = "id_langue";

    //Creation table associative
    private static final String CREATE_TABLE_LANGUE_PERSONNE = "CREATE TABLE IF NOT EXISTS " + TABLE_LANGUE_PERSONNE +
            "(" + COL_LOGIN_PERSONNE_LP + " TEXT NOT NULL," +
            COL_ID_LANGUE_LU + " INTEGER NOT NULL," +
            "FOREIGN KEY (" + COL_LOGIN_PERSONNE_LP + ") REFERENCES " + TABLE_PERSONNE + "(" + COL_LOGIN_PERSONNE + ")," +
            "FOREIGN KEY (" + COL_ID_LANGUE_LU + ") REFERENCES " + TABLE_LANGUE + "(" + COL_ID_LANGUE + "));";

    //Suppression table associative
    private static final String DROP_TABLE_LANGUE_PERSONNE = "DROP TABLE IF EXISTS " + TABLE_LANGUE_PERSONNE + ";";

    //===============================Table association entre enseigne et langue============================//

    public static final String TABLE_LANGUE_ENSEIGNE = "LangueEnseigne";
    public static final String COL_LOGIN_ENSEIGNE_LE = "login_enseigne";
    public static final String COL_ID_LANGUE_LE = "id_langue";

    //Creation table associative
    private static final String CREATE_TABLE_LANGUE_ENSEIGNE = "CREATE TABLE IF NOT EXISTS " + TABLE_LANGUE_ENSEIGNE +
            "(" + COL_LOGIN_ENSEIGNE_LE + " TEXT NOT NULL," +
            COL_ID_LANGUE_LE + " INTEGER NOT NULL," +
            "FOREIGN KEY (" + COL_LOGIN_ENSEIGNE_LE + ") REFERENCES " + TABLE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE + ")," +
            "FOREIGN KEY (" + COL_ID_LANGUE_LE + ") REFERENCES " + TABLE_LANGUE + "(" + COL_ID_LANGUE + "));";

    //Suppression table associative
    private static final String DROP_TABLE_LANGUE_ENSEIGNE = "DROP TABLE IF EXISTS " + TABLE_LANGUE_ENSEIGNE + ";";

    //===============================Table association Favoris personne=================================//
    public static final String TABLE_FAVORIS_P = "FavorisP";
    public static final String COL_LOGIN_PERSONNE_F = "login_personne";
    public static final String COL_LOGIN_FAVORIS_F = "login_favoris_p";

    //Creation table association
    private static final String CREATE_TABLE_FAVORIS_P = "CREATE TABLE IF NOT EXISTS " + TABLE_FAVORIS_P +
            "(" + COL_LOGIN_PERSONNE_F + " TEXT NOT NULL," +
            COL_LOGIN_FAVORIS_F + " TEXT NOT NULL," +
            "FOREIGN KEY (" + COL_LOGIN_PERSONNE_F + ") REFERENCES " + TABLE_PERSONNE + "(" + COL_LOGIN_PERSONNE + ")," +
            "FOREIGN KEY (" + COL_LOGIN_FAVORIS_F + ") REFERENCES " + TABLE_PERSONNE + "(" + COL_LOGIN_PERSONNE + "));";

    //Suppression table association
    private static final String DROP_TABLE_FAVORIS_P = "DROP TABLE IF EXISTS " + TABLE_FAVORIS_P + ";";

    //===============================Table association Favoris enseigne=================================//
    public static final String TABLE_FAVORIS_E = "FavorisE";
    public static final String COL_LOGIN_PERSONNE_FE = "login_personne";
    public static final String COL_LOGIN_FAVORIS_E = "login_favoris_e";

    //Creation table assoc
    private static final String CREATE_TABLE_FAVORIS_E = "CREATE TABLE IF NOT EXISTS " + TABLE_FAVORIS_E +
            "(" + COL_LOGIN_PERSONNE_FE + " TEXT NOT NULL," +
            COL_LOGIN_FAVORIS_E + " TEXT NOT NULL," +
            "FOREIGN KEY (" + COL_LOGIN_PERSONNE_FE + ") REFERENCES " + TABLE_PERSONNE + "(" + COL_LOGIN_PERSONNE + ")," +
            "FOREIGN KEY (" + COL_LOGIN_FAVORIS_E + ") REFERENCES " + TABLE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE + "));";

    //Suppression table assoc
    private static final String DROP_TABLE_FAVORIS_E = "DROP TABLE IF EXISTS " + TABLE_FAVORIS_E + ";";

    //=======================================Table Evenement=====================================//
    public static final String TABLE_EVENEMENT = "Evenement";
    public static final String COL_ID_EVENEMENT = "id_evenement";
    public static final String COL_INTITULE = "intitule";
    public static final String COL_DESCRIPTION_EV = "description_e";
    public static final String COL_ADRESSE_EV = "adresse_e";
    public static final String COL_DATE_DEBUT = "date_debut";
    public static final String COL_DATE_FIN = "date_fin";
    public static final String COL_H_DEBUT = "h_debut_evenement";
    public static final String COL_H_FIN = "h_fin_evenement";
    public static final String COL_LOGIN_P_E = "login_personne";

    //Creation table Evenement
    private static final String CREATE_TABLE_EVENEMENT = "CREATE TABLE IF NOT EXISTS " + TABLE_EVENEMENT +
            "(" + COL_ID_EVENEMENT + " INTEGER PRIMARY KEY AUTOINCREMENT," + COL_INTITULE + " TEXT," +
            COL_DESCRIPTION_EV + " TEXT ," + COL_ADRESSE_EV + " TEXT ," + COL_DATE_DEBUT + " TEXT," + COL_DATE_FIN + " TEXT,"
            + COL_H_DEBUT + " TEXT," + COL_H_FIN + " TEXT," + COL_LOGIN_P_E + " TEXT NOT NULL," +
            "FOREIGN KEY (" + COL_LOGIN_P_E + ") REFERENCES " + TABLE_FAVORIS_P + "(" + COL_LOGIN_FAVORIS_F + "));";

    //Suppression table Evenement
    private static final String DROP_TABLE_EVENEMENT = "DROP TABLE IF EXISTS " + TABLE_EVENEMENT + ";";

    //==============================================Table Invités===============================//
    public static final String TABLE_INVITE = "inviteevenement";
    public static final String COL_LOGIN_FAVORIS_INVITE = "login_favoris_p";
    public static final String COL_ID_EVENEMENT_INVIT = "id_evenement";
    public static final String COL_INVITE_STATUT = "statut";

    //Creation table Invité
    private static final String CREATE_TABLE_INVITE = "CREATE TABLE IF NOT EXISTS " + TABLE_INVITE +
            "(" + COL_LOGIN_FAVORIS_INVITE + " TEXT NOT NULL," + COL_ID_EVENEMENT_INVIT + " TEXT NOT NULL," +
            COL_INVITE_STATUT + " INTEGER ," +
            "FOREIGN KEY (" + COL_LOGIN_FAVORIS_INVITE + ") REFERENCES " + TABLE_FAVORIS_P + "(" + COL_LOGIN_PERSONNE_F + ")" +
            "FOREIGN KEY (" + COL_ID_EVENEMENT_INVIT + ") REFERENCES " + TABLE_EVENEMENT + "(" + COL_ID_EVENEMENT + "));";

    //Suppression table Invité
    private static final String DROP_TABLE_INVITE = "DROP TABLE IF EXISTS " + TABLE_INVITE + ";";

    //=================================== insertion de quelques données ====================================//
    //Bures
    private static final String INSERT_LOC2 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  ('2' , '48.699373' , '2.171295');";
    private static final String INSERT_LOC3 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  ('3' , '48.859407' , '2.349344');";
    private static final String INSERT_LOC4 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  ('4' , '48.693375' , '2.15776');";
    //Naterre
    private static final String INSERT_LOC5 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  ('5' , '48.8993' , '2.209665');";
    private static final String INSERT_LOC1 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  ('1' , '48.905013','2.214943');";
    private static final String INSERT_LOC6 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES ('6','48.840193' , '2.349829');";

    private static final String INSERT_PERSONNE1 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  ('nacer' , '12345', '1' , 'nacer');";
    private static final String INSERT_PERSONNE2 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  ('cedric' , '12345', '2' , 'cedric');";
    private static final String INSERT_PERSONNE3 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  ('andrea' , '12345', '3' , 'andrea');";
    private static final String INSERT_PERSONNE4 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  ('a' , 'a', '' , 'test');";


    private static final String INSERT_LANGUE1 = "INSERT INTO " + TABLE_LANGUE + "(" + COL_ID_LANGUE + "," + COL_NOM_LANGUE + ") VALUES  ('1','French');";
    private static final String INSERT_LANGUE2 = "INSERT INTO " + TABLE_LANGUE + "(" + COL_ID_LANGUE + "," + COL_NOM_LANGUE + ") VALUES  ('2','English');";
    private static final String INSERT_LANGUE3 = "INSERT INTO " + TABLE_LANGUE + "(" + COL_ID_LANGUE + "," + COL_NOM_LANGUE + ") VALUES  ('3','Spanish');";
    private static final String INSERT_LANGUE4 = "INSERT INTO " + TABLE_LANGUE + "(" + COL_ID_LANGUE + "," + COL_NOM_LANGUE + ") VALUES  ('4','Dutsh');";
    private static final String INSERT_LANGUE5 = "INSERT INTO " + TABLE_LANGUE + "(" + COL_ID_LANGUE + "," + COL_NOM_LANGUE + ") VALUES  ('5','Italian');";
    private static final String INSERT_LANGUE6 = "INSERT INTO " + TABLE_LANGUE + "(" + COL_ID_LANGUE + "," + COL_NOM_LANGUE + ") VALUES  ('6','Chinese');";
    private static final String INSERT_LANGUE7 = "INSERT INTO " + TABLE_LANGUE + "(" + COL_ID_LANGUE + "," + COL_NOM_LANGUE + ") VALUES  ('7','Japanese');";

    private static final String INSERT_LANGUE_ENSEIGNE1 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('bistro','1');";
    private static final String INSERT_LANGUE_ENSEIGNE2 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('ramoneur','2');";
    private static final String INSERT_LANGUE_ENSEIGNE3 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('macDo','5');";
    private static final String INSERT_LANGUE_ENSEIGNE5 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('kirane','5');";
    private static final String INSERT_LANGUE_ENSEIGNE6 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('idees','2');";
    private static final String INSERT_LANGUE_ENSEIGNE7 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('krishna','4');";
    private static final String INSERT_LANGUE_ENSEIGNE8 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('yasube','6');";
    private static final String INSERT_LANGUE_ENSEIGNE9 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('anahuacalli','1');";
    private static final String INSERT_LANGUE_ENSEIGNE10 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('porta','6');";
    private static final String INSERT_LANGUE_ENSEIGNE11 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('toto','6');";
    private static final String INSERT_LANGUE_ENSEIGNE12 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('gioia','3');";
    private static final String INSERT_LANGUE_ENSEIGNE13 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('mog','4');";
    private static final String INSERT_LANGUE_ENSEIGNE14 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('pousee','1');";
    private static final String INSERT_LANGUE_ENSEIGNE15 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('boco','5');";
    private static final String INSERT_LANGUE_ENSEIGNE16 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('fogon','1');";
    private static final String INSERT_LANGUE_ENSEIGNE17 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('menkes','2');";
    private static final String INSERT_LANGUE_ENSEIGNE18 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('thanksgivin','3');";
    private static final String INSERT_LANGUE_ENSEIGNE19 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('mikhail','3');";
    private static final String INSERT_LANGUE_ENSEIGNE20 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('kazuko','6');";
    private static final String INSERT_LANGUE_ENSEIGNE21 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('hobo','1');";
    private static final String INSERT_LANGUE_ENSEIGNE22 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('memories','4');";
    private static final String INSERT_LANGUE_ENSEIGNE23 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('peter','1');";
    private static final String INSERT_LANGUE_ENSEIGNE24 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('canelas','6');";
    private static final String INSERT_LANGUE_ENSEIGNE25 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('comptoir','2');";
    private static final String INSERT_LANGUE_ENSEIGNE26 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('junku','2');";
    private static final String INSERT_LANGUE_ENSEIGNE27 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('cite','1');";
    private static final String INSERT_LANGUE_ENSEIGNE28 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('paulo','5');";
    private static final String INSERT_LANGUE_ENSEIGNE29 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('desmos','6');";
    private static final String INSERT_LANGUE_ENSEIGNE30 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('jeanpierre','1');";
    private static final String INSERT_LANGUE_ENSEIGNE31 = "INSERT INTO " + TABLE_LANGUE_ENSEIGNE + "(" + COL_LOGIN_ENSEIGNE_LE + " , " + COL_ID_LANGUE_LE + ") VALUES  ('babel','2');";


    private static final String INSERT_LANGUE_PERSONNE1 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('nacer','1');";
    private static final String INSERT_LANGUE_PERSONNE2 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('cedric','2');";
    private static final String INSERT_LANGUE_PERSONNE3 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('andrea','3');";
    private static final String INSERT_LANGUE_PERSONNE4 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('a','3');";
    private static final String INSERT_LANGUE_PERSONNE5 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('claire','3');";
    private static final String INSERT_LANGUE_PERSONNE6 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('jackson','4');";
    private static final String INSERT_LANGUE_PERSONNE7 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('maxime','1');";
    private static final String INSERT_LANGUE_PERSONNE8 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('thomas','1');";
    private static final String INSERT_LANGUE_PERSONNE9 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('philippe','3');";
    private static final String INSERT_LANGUE_PERSONNE10 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('julien','1');";
    private static final String INSERT_LANGUE_PERSONNE11 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('jude','3');";
    private static final String INSERT_LANGUE_PERSONNE12 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('elise','6');";
    private static final String INSERT_LANGUE_PERSONNE13 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('diandra','4');";
    private static final String INSERT_LANGUE_PERSONNE14 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('moussa','1');";
    private static final String INSERT_LANGUE_PERSONNE15 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('mai','3');";
    private static final String INSERT_LANGUE_PERSONNE16 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('lan','2');";
    private static final String INSERT_LANGUE_PERSONNE17 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('brahim','3');";
    private static final String INSERT_LANGUE_PERSONNE18 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('karima','6');";
    private static final String INSERT_LANGUE_PERSONNE19 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('kabine','3');";
    private static final String INSERT_LANGUE_PERSONNE20 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('nicole','3');";
    private static final String INSERT_LANGUE_PERSONNE21 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('momar','5');";
    private static final String INSERT_LANGUE_PERSONNE22 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('akouiass','1');";
    private static final String INSERT_LANGUE_PERSONNE23 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('john','4');";
    private static final String INSERT_LANGUE_PERSONNE24 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('pedro','2');";
    private static final String INSERT_LANGUE_PERSONNE25 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('beatriz','1');";
    private static final String INSERT_LANGUE_PERSONNE26 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('paula','5');";
    private static final String INSERT_LANGUE_PERSONNE27 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('ceci','6');";
    private static final String INSERT_LANGUE_PERSONNE28 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('frantz','4');";
    private static final String INSERT_LANGUE_PERSONNE29 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('lee','3');";
    private static final String INSERT_LANGUE_PERSONNE30 = "INSERT INTO " + TABLE_LANGUE_PERSONNE + "(" + COL_LOGIN_PERSONNE_LP + " , " + COL_ID_LANGUE_LU + ") VALUES  ('eric','5');";

    //insertion localisation personnes

    private static final String INSERT_LOC7 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"7\" , \"48.904928\" , \"2.216059\");";
    private static final String INSERT_LOC8 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"8\" , \"48.896662\" , \"2.244129\");";
    private static final String INSERT_LOC9 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"9\" , \"48.879506\" , \"2.299377\");";
    private static final String INSERT_LOC10 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"10\" , \"48.875329\" , \"2.289249\");";
    private static final String INSERT_LOC11 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"11\" , \"48.860198\" , \"2.299549\");";
    private static final String INSERT_LOC12 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"12\" , \"48.844158\" , \"2.284786\");";
    private static final String INSERT_LOC13 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"13\" , \"48.870699\" , \"2.31414\");";
    private static final String INSERT_LOC14 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"14\" , \"48.854889\" , \"2.347957\");";
    private static final String INSERT_LOC15 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"15\" , \"48.836814\" , \"2.343494\");";
    private static final String INSERT_LOC16 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"16\" , \"48.81975\" , \"2.314999\");";
    private static final String INSERT_LOC17 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"17\" , \"48.863924\" , \"2.36478\");";
    private static final String INSERT_LOC18 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"18\" , \"48.88436\" , \"2.383148\");";
    private static final String INSERT_LOC19 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"19\" , \"48.851388\" , \"2.394478\");";
    private static final String INSERT_LOC20 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"20\" , \"48.845288\" , \"2.288734\");";
    private static final String INSERT_LOC21 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"21\" , \"48.866522\" , \"2.286133\");";
    private static final String INSERT_LOC22 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"22\" , \"48.822463\" , \"2.25695\");";
    private static final String INSERT_LOC23 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"23\" , \"48.862908\" , \"2.24871\");";
    private static final String INSERT_LOC24 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"24\" , \"48.884586\" , \"2.194465\");";
    private static final String INSERT_LOC25 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"25\" , \"48.907044\" , \"2.19957\");";
    private static final String INSERT_LOC26 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"26\" , \"48.907326\" , \"2.2218\");";
    private static final String INSERT_LOC27 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"27\" , \"48.903433\" , \"2.216993\");";
    private static final String INSERT_LOC28 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"28\" , \"48.902023\" , \"2.212444\");";
    private static final String INSERT_LOC29 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"29\" , \"48.854889\" , \"2.348957\");";
    private static final String INSERT_LOC30 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"30\" , \"48.866522\" , \"2.287133\");";

    //insertion localisation ENSEIGNE
    private static final String INSERT_LOC31 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"31\" , \"48.88896\" , \"2.249297\");";
    private static final String INSERT_LOC32 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"32\" , \"48.885715\" , \"2.319633\");";
    private static final String INSERT_LOC33 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"33\" , \"48.858278\" , \"2.332165\");";
    private static final String INSERT_LOC34 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"34\" , \"48.879957\" , \"2.386238\");";
    private static final String INSERT_LOC35 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"35\" , \"48.851049\" , \"2.393448\");";
    private static final String INSERT_LOC36 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"36\" , \"48.891295\" , \"2.235609\");";
    private static final String INSERT_LOC37 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"37\" , \"48.877925\" , \"2.409241\");";
    private static final String INSERT_LOC38 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"38\" , \"48.849129\" , \"2.381775\");";
    private static final String INSERT_LOC39 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"39\" , \"48.828566\" , \"2.359115\");";
    private static final String INSERT_LOC40 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"40\" , \"48.881651\" , \"2.170631\");";
    private static final String INSERT_LOC41 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"41\" , \"48.892466\" , \"2.239106\");";
    private static final String INSERT_LOC42 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"42\" , \"48.886166\" , \"2.179558\");";
    private static final String INSERT_LOC43 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"43\" , \"48.886166\" , \"2.166511\");";
    private static final String INSERT_LOC44 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"44\" , \"48.918777\" , \"2.250282\");";
    private static final String INSERT_LOC45 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"45\" , \"48.846756\" , \"2.348314\");";
    private static final String INSERT_LOC46 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"46\" , \"48.922725\" , \"2.339031\");";
    private static final String INSERT_LOC47 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"47\" , \"48.889665\" , \"2.381088\");";
    private static final String INSERT_LOC48 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"48\" , \"48.858729\" , \"2.380058\");";
    private static final String INSERT_LOC49 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"49\" , \"48.8576\" , \"2.356026\");";
    private static final String INSERT_LOC50 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"50\" , \"48.822562\" , \"2.334205\");";
    private static final String INSERT_LOC51 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"51\" , \"48.907044\" , \"2.337658\");";
    private static final String INSERT_LOC52 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"52\" , \"48.890582\" , \"2.238398\");";
    private static final String INSERT_LOC53 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"53\" , \"48.820132\" , \"2.338647\");";
    private static final String INSERT_LOC54 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"54\" , \"48.839441\" , \"2.333\");";
    private static final String INSERT_LOC55 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"55\" , \"48.822562\" , \"2.334205\");";
    private static final String INSERT_LOC56 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"56\" , \"48.892987\" , \"2.242432\");";
    private static final String INSERT_LOC57 = "INSERT INTO " + TABLE_LOCALISATION + "(" + COL_ID_LOC + "," + COL_LATITUDE + "," + COL_LONGITUDE + ") VALUES  (\"57\" , \"48.830967\" , \"2.315319\");";

    //insertion personnes
    private static final String INSERT_PERSONNE5 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"claire\" , \"12345\", \"5\" , \"claire\");";
    private static final String INSERT_PERSONNE6 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"jackson\" , \"12345\", \"6\" , \"jackson\");";
    private static final String INSERT_PERSONNE7 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"maxime\" , \"12345\", \"7\" , \"maxime\");";
    private static final String INSERT_PERSONNE8 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"thomas\" , \"12345\", \"8\" , \"thomas\");";
    private static final String INSERT_PERSONNE9 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"philippe\" , \"12345\", \"9\" , \"philippe\");";
    private static final String INSERT_PERSONNE10 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"julien\" , \"12345\", \"10\" , \"julien\");";
    private static final String INSERT_PERSONNE11 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"jude\" , \"12345\", \"11\" , \"jude\");";
    private static final String INSERT_PERSONNE12 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"elise\" , \"12345\", \"12\" , \"elise\");";
    private static final String INSERT_PERSONNE13 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"diandra\" , \"12345\", \"13\" , \"diandra\");";
    private static final String INSERT_PERSONNE14 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"moussa\" , \"12345\", \"14\" , \"moussa\");";
    private static final String INSERT_PERSONNE15 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"mai\" , \"12345\", \"15\" , \"mai\");";
    private static final String INSERT_PERSONNE16 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"lan\" , \"12345\", \"16\" , \"lan\");";
    private static final String INSERT_PERSONNE17 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"brahim\" , \"12345\", \"17\" , \"brahim\");";
    private static final String INSERT_PERSONNE18 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"karima\" , \"12345\", \"18\" , \"karima\");";
    private static final String INSERT_PERSONNE19 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"kabine\" , \"12345\", \"19\" , \"kabine\");";
    private static final String INSERT_PERSONNE20 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"nicole\" , \"12345\", \"20\" , \"nicole\");";
    private static final String INSERT_PERSONNE21 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"momar\" , \"12345\", \"21\" , \"momar\");";
    private static final String INSERT_PERSONNE22 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"akouiass\" , \"12345\", \"22\" , \"akouiass\");";
    private static final String INSERT_PERSONNE23 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"john\" , \"12345\", \"23\" , \"john\");";
    private static final String INSERT_PERSONNE24 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"pedro\" , \"12345\", \"24\" , \"pedro\");";
    private static final String INSERT_PERSONNE25 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"beatriz\" , \"12345\", \"25\" , \"beatriz\");";
    private static final String INSERT_PERSONNE26 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"paula\" , \"12345\", \"26\" , \"paula\");";
    private static final String INSERT_PERSONNE27 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"ceci\" , \"12345\", \"27\" , \"ceci\");";
    private static final String INSERT_PERSONNE28 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"frantz\" , \"12345\", \"28\" , \"frantz\");";
    private static final String INSERT_PERSONNE29 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"lee\" , \"12345\", \"29\" , \"lee\");";
    private static final String INSERT_PERSONNE30 = "INSERT INTO " + TABLE_PERSONNE + " (" + COL_LOGIN_PERSONNE + "," + COL_PWD_PERSONNE + "," + COL_ID_LOC_P + "," + COL_PSEUDO + ") VALUES  (\"eric\" , \"12345\", \"30\" , \"eric\");";

    //insertion ENSEIGNE
    private static final String INSERT_ENSEIGNE1 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  ('bistro' , '12345' , 'Bistrot Romain', \"Un bistrot traditionnel, le personnel parle aussi bien anglais que\'espagnol\", '4',\"9\", \"16\");";
    private static final String INSERT_ENSEIGNE2 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  ('ramoneur' , '12345' , 'Le ramoneur de paris' , \"Ramoneur de père en fils je connais la ville comme ma poche, besoin d\'aide?\", '5',\"9\", \"16\");";
    private static final String INSERT_ENSEIGNE3 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"macDo\" , \"12345\" , \"Macdo\" , \"Vive le macdo\", \"6\", \"8\", \"18\");";
    private static final String INSERT_ENSEIGNE5 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"kirane\" , \"12345\" , \" Kirane's et Nirvana‎\", \"Restaurant indien\", \"31\", \"10\", \"18\");";
    private static final String INSERT_ENSEIGNE6 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"idees\" , \"12345\" , \"Les Idées Restos\", \"Restaurant Etrangers\", \"32\", \"8\", \"18\");";
    private static final String INSERT_ENSEIGNE7 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"krishna\" , \"12345\" , \"Krishna-bhavan \",\" spécialités indiennes et végétariennes\", \"33\", \"10\", \"18\");";
    private static final String INSERT_ENSEIGNE8 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"yasube\" , \"12345\" , \"Yasube\", \"Restaurant japonais\", \"34\", \"9\", \"16\");";
    private static final String INSERT_ENSEIGNE9 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"anahuacalli\" , \"12345\" , \"Anahuacalli\", \"Manger mexicain\", \"35\", \"10\", \"18\");";
    private static final String INSERT_ENSEIGNE10 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"porta\" , \"12345\" , \"Restaurant Porta da Selva\", \"Restaurant Bresilien\", \"36\", \"10\", \"17\");";
    private static final String INSERT_ENSEIGNE11 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"toto\" , \"12345\" , \"Ristorante da Totò e Peppino\", \"Gastronomie italienne\", \"37\", \"11\", \"20\");";
    private static final String INSERT_ENSEIGNE12 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"gioia\" , \"12345\" , \"Gioia mia\", \"Petit resto italien\", \"38\", \"8\", \"18\");";
    private static final String INSERT_ENSEIGNE13 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"mog\" , \"12345\" , \"Mog Mog Japon\", \"Restaurant japonais\", \"39\", \"8\", \"16\");";
    private static final String INSERT_ENSEIGNE14 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"pousee\" , \"12345\" , \"Pousse-pousse\", \"Restaurants bio/végétariens\", \"40\", \"8\", \"18\");";
    private static final String INSERT_ENSEIGNE15 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + ","+ COL_H_FERMETURE + ") VALUES  (\"boco\" , \"12345\" , \"Boco : du bio en bocaux\", \"Restaurants bio/végétariens\", \"41\", \"10\", \"18\");";
    private static final String INSERT_ENSEIGNE16 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"fogon\" , \"12345\" , \"El fogón de san Julián\", \"Cuisine espagnole \", \"42\", \"11\", \"18\");";
    private static final String INSERT_ENSEIGNE17 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"menkes\",\"12345\",\"Menkes\",\"Flamenko\",\"43\", \"8\", \"18\");";
    private static final String INSERT_ENSEIGNE18 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"thanksgivin\" , \"12345\", \"Thanksgiving\", \"Resto Américain\", \"44\", \"9\", \"18\");";
    private static final String INSERT_ENSEIGNE19 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + ","+ COL_H_FERMETURE + ") VALUES  (\"mikhail\" , \"12345\", \"Mikhaïl Rudy\", \"Librairie russe\", \"45\", \"14\", \"21\");";
    private static final String INSERT_ENSEIGNE20 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"kazuko\" , \"12345\", \"Kazuko Masui\",\"Gastronomie Japonaise \", \"46\", \"10\", \"18\");";
    private static final String INSERT_ENSEIGNE21 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," +COL_H_FERMETURE + ") VALUES  (\"hobo\" , \"12345\", \"Hobo\",\" Musique  Anglaise\", \"47\", \"9\", \"18\");";
    private static final String INSERT_ENSEIGNE22 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"memories\" ,\"12345\",\"Mémoires de porc-épic\",\"Galerie Congolaise\",\"48\", \"10\", \"18\");";
    private static final String INSERT_ENSEIGNE23 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"peter\" ,\"12345\",\"Peter von Poehl\",\"Musicien suédoise\", \"49\", \"9\", \"18\");";
    private static final String INSERT_ENSEIGNE24 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"canelas\" ,\"12345\",\"Canelas\",\"Concert portugais\",\"50\", \"8\", \"18\");";
    private static final String INSERT_ENSEIGNE25 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"comptoir\" ,\"12345\",\"Comptoir de Tunisie\",\"Magasin\",\"51\", \"9\", \"18\");";
    private static final String INSERT_ENSEIGNE26 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"junku\",\"12345\",\"JUNKU\",\"Librairie Japonaise\",\"52\", \"10\", \"16\");";
    private static final String INSERT_ENSEIGNE27 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE +") VALUES  (\"cite\",\"12345\",\"Cité Internationale Universitaire\",\"Maison Internationale \",\"53\", \"12\", \"18\");";
    private static final String INSERT_ENSEIGNE28 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"paulo\",\"12345\",\"Dr. Paulo Da Silva Moreira\",\"Docteur Portugais\",\"54\", \"9\", \"16\");";
    private static final String INSERT_ENSEIGNE29 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"desmos\" ,\"12345\",\"Desmos\",\"Librairie Grecque\",\"55\", \"8\", \"18\");";
    private static final String INSERT_ENSEIGNE30 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"jeanpierre\",\"12345\",\"Docteur Jean Pierre Viltart\",\"Docteur Espagnol\",\"56\", \"8\", \"16\");";
    private static final String INSERT_ENSEIGNE31 = "INSERT INTO " + TABLE_ENSEIGNE + " (" + COL_LOGIN_ENSEIGNE + "," + COL_PWD_Enseigne + "," + COL_NOM_ENSEIGNE + "," + COL_DESC_ENSEIGNE + "," + COL_ID_LOC_E + "," + COL_H_OUVERTURE + "," + COL_H_FERMETURE + ") VALUES  (\"babel\",\"12345\",\"Tour de Babel\",\"Librairie italienne\",\"57\", \"14\", \"21\");";


    public BdLocatme(Context context) {
        super(context, NOM_BDD, null, VERSION_BDD);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        //To change body of implemented methods use File | Settings | File Templates.
        db.execSQL(CREATE_TABLE_TYPE_ETAB);
        db.execSQL(CREATE_TABLE_LOCALISATION);
        db.execSQL(CREATE_TABLE_NOTE);
        db.execSQL(CREATE_TABLE_ENSEIGNE);
        db.execSQL(CREATE_TABLE_PERSONNE);
        db.execSQL(CREATE_TABLE_COMMENTAIRE);
        db.execSQL(CREATE_TABLE_MESSAGE);
        db.execSQL(CREATE_TABLE_LANGUE);
        db.execSQL(CREATE_TABLE_LANGUE_ENSEIGNE);
        db.execSQL(CREATE_TABLE_LANGUE_PERSONNE);
        db.execSQL(CREATE_TABLE_FAVORIS_P);
        db.execSQL(CREATE_TABLE_FAVORIS_E);
        db.execSQL(CREATE_TABLE_EVENEMENT);
        db.execSQL(CREATE_TABLE_INVITE);
        db.execSQL(INSERT_PERSONNE1);
        db.execSQL(INSERT_PERSONNE2);
        db.execSQL(INSERT_PERSONNE3);
        db.execSQL(INSERT_PERSONNE4);
        db.execSQL(INSERT_PERSONNE5);
        db.execSQL(INSERT_PERSONNE6);
        db.execSQL(INSERT_PERSONNE7);
        db.execSQL(INSERT_PERSONNE8);
        db.execSQL(INSERT_PERSONNE9);
        db.execSQL(INSERT_PERSONNE10);
        db.execSQL(INSERT_PERSONNE11);
        db.execSQL(INSERT_PERSONNE12);
        db.execSQL(INSERT_PERSONNE13);
        db.execSQL(INSERT_PERSONNE14);
        db.execSQL(INSERT_PERSONNE15);
       /* db.execSQL(INSERT_PERSONNE16);
        db.execSQL(INSERT_PERSONNE17);
        db.execSQL(INSERT_PERSONNE18);
        db.execSQL(INSERT_PERSONNE19);
        db.execSQL(INSERT_PERSONNE20);
        db.execSQL(INSERT_PERSONNE21);
        db.execSQL(INSERT_PERSONNE22);
        db.execSQL(INSERT_PERSONNE23);
        db.execSQL(INSERT_PERSONNE24);
        db.execSQL(INSERT_PERSONNE25);
        db.execSQL(INSERT_PERSONNE26);
        db.execSQL(INSERT_PERSONNE27);
        db.execSQL(INSERT_PERSONNE28);
        db.execSQL(INSERT_PERSONNE29);
        db.execSQL(INSERT_PERSONNE30);*/

        db.execSQL(INSERT_LANGUE1);
        db.execSQL(INSERT_LANGUE2);
        db.execSQL(INSERT_LANGUE3);
        db.execSQL(INSERT_LANGUE4);
        db.execSQL(INSERT_LANGUE5);
        db.execSQL(INSERT_LANGUE6);
        db.execSQL(INSERT_LANGUE7);
        db.execSQL(INSERT_LANGUE_ENSEIGNE1);
        db.execSQL(INSERT_LANGUE_ENSEIGNE2);
        db.execSQL(INSERT_LANGUE_ENSEIGNE3);
        db.execSQL(INSERT_LANGUE_ENSEIGNE5);
        db.execSQL(INSERT_LANGUE_ENSEIGNE6);
        db.execSQL(INSERT_LANGUE_ENSEIGNE7);
        db.execSQL(INSERT_LANGUE_ENSEIGNE8);
        db.execSQL(INSERT_LANGUE_ENSEIGNE9);
        db.execSQL(INSERT_LANGUE_ENSEIGNE10);
        db.execSQL(INSERT_LANGUE_ENSEIGNE11);
        db.execSQL(INSERT_LANGUE_ENSEIGNE12);
        db.execSQL(INSERT_LANGUE_ENSEIGNE13);
        db.execSQL(INSERT_LANGUE_ENSEIGNE14);
        db.execSQL(INSERT_LANGUE_ENSEIGNE15);
      /*  db.execSQL(INSERT_LANGUE_ENSEIGNE16);
        db.execSQL(INSERT_LANGUE_ENSEIGNE17);
        db.execSQL(INSERT_LANGUE_ENSEIGNE18);
        db.execSQL(INSERT_LANGUE_ENSEIGNE19);
        db.execSQL(INSERT_LANGUE_ENSEIGNE20);
        db.execSQL(INSERT_LANGUE_ENSEIGNE21);
        db.execSQL(INSERT_LANGUE_ENSEIGNE22);
        db.execSQL(INSERT_LANGUE_ENSEIGNE23);
        db.execSQL(INSERT_LANGUE_ENSEIGNE24);
        db.execSQL(INSERT_LANGUE_ENSEIGNE25);
        db.execSQL(INSERT_LANGUE_ENSEIGNE26);
        db.execSQL(INSERT_LANGUE_ENSEIGNE27);
        db.execSQL(INSERT_LANGUE_ENSEIGNE28);
        db.execSQL(INSERT_LANGUE_ENSEIGNE29);
        db.execSQL(INSERT_LANGUE_ENSEIGNE30);
        db.execSQL(INSERT_LANGUE_ENSEIGNE31);*/

        db.execSQL(INSERT_LANGUE_PERSONNE1);
        db.execSQL(INSERT_LANGUE_PERSONNE2);
        db.execSQL(INSERT_LANGUE_PERSONNE3);
        db.execSQL(INSERT_LANGUE_PERSONNE4);
        db.execSQL(INSERT_LANGUE_PERSONNE5);
        db.execSQL(INSERT_LANGUE_PERSONNE6);
        db.execSQL(INSERT_LANGUE_PERSONNE7);
        db.execSQL(INSERT_LANGUE_PERSONNE8);
        db.execSQL(INSERT_LANGUE_PERSONNE9);
        db.execSQL(INSERT_LANGUE_PERSONNE10);
        db.execSQL(INSERT_LANGUE_PERSONNE11);
        db.execSQL(INSERT_LANGUE_PERSONNE12);
        db.execSQL(INSERT_LANGUE_PERSONNE13);
        db.execSQL(INSERT_LANGUE_PERSONNE14);
        db.execSQL(INSERT_LANGUE_PERSONNE15);
       /* db.execSQL(INSERT_LANGUE_PERSONNE16);
        db.execSQL(INSERT_LANGUE_PERSONNE17);
        db.execSQL(INSERT_LANGUE_PERSONNE18);
        db.execSQL(INSERT_LANGUE_PERSONNE19);
        db.execSQL(INSERT_LANGUE_PERSONNE20);
        db.execSQL(INSERT_LANGUE_PERSONNE21);
        db.execSQL(INSERT_LANGUE_PERSONNE22);
        db.execSQL(INSERT_LANGUE_PERSONNE23);
        db.execSQL(INSERT_LANGUE_PERSONNE24);
        db.execSQL(INSERT_LANGUE_PERSONNE25);
        db.execSQL(INSERT_LANGUE_PERSONNE26);
        db.execSQL(INSERT_LANGUE_PERSONNE27);
        db.execSQL(INSERT_LANGUE_PERSONNE28);
        db.execSQL(INSERT_LANGUE_PERSONNE29);
        db.execSQL(INSERT_LANGUE_PERSONNE30);*/


        db.execSQL(INSERT_LOC1);
        db.execSQL(INSERT_LOC2);
        db.execSQL(INSERT_LOC3);
        db.execSQL(INSERT_LOC4);
        db.execSQL(INSERT_LOC5);
        db.execSQL(INSERT_LOC6);
        db.execSQL(INSERT_LOC7);
        db.execSQL(INSERT_LOC8);
        db.execSQL(INSERT_LOC9);
        db.execSQL(INSERT_LOC10);
        db.execSQL(INSERT_LOC11);
        db.execSQL(INSERT_LOC12);
        db.execSQL(INSERT_LOC13);
        db.execSQL(INSERT_LOC14);
        db.execSQL(INSERT_LOC15);
        db.execSQL(INSERT_LOC16);
        db.execSQL(INSERT_LOC17);
        db.execSQL(INSERT_LOC18);
        db.execSQL(INSERT_LOC19);
        db.execSQL(INSERT_LOC20);
        db.execSQL(INSERT_LOC21);
        db.execSQL(INSERT_LOC22);
        db.execSQL(INSERT_LOC23);
        db.execSQL(INSERT_LOC24);
        db.execSQL(INSERT_LOC25);
        db.execSQL(INSERT_LOC26);
        db.execSQL(INSERT_LOC27);
        db.execSQL(INSERT_LOC28);
        db.execSQL(INSERT_LOC29);
        db.execSQL(INSERT_LOC30);
        db.execSQL(INSERT_LOC31);
        db.execSQL(INSERT_LOC32);
        db.execSQL(INSERT_LOC33);
        db.execSQL(INSERT_LOC34);
        db.execSQL(INSERT_LOC35);
        db.execSQL(INSERT_LOC36);
        db.execSQL(INSERT_LOC37);
        db.execSQL(INSERT_LOC38);
        db.execSQL(INSERT_LOC39);
        db.execSQL(INSERT_LOC40);
        db.execSQL(INSERT_LOC41);
        db.execSQL(INSERT_LOC42);
        db.execSQL(INSERT_LOC43);
        db.execSQL(INSERT_LOC44);
        db.execSQL(INSERT_LOC45);
        db.execSQL(INSERT_LOC46);
        db.execSQL(INSERT_LOC47);
        db.execSQL(INSERT_LOC48);
        db.execSQL(INSERT_LOC49);
        db.execSQL(INSERT_LOC50);
        db.execSQL(INSERT_LOC51);
        db.execSQL(INSERT_LOC52);
        db.execSQL(INSERT_LOC53);
        db.execSQL(INSERT_LOC54);
        db.execSQL(INSERT_LOC55);
        db.execSQL(INSERT_LOC56);
        db.execSQL(INSERT_LOC57);
        db.execSQL(INSERT_ENSEIGNE1);
        db.execSQL(INSERT_ENSEIGNE2);
        db.execSQL(INSERT_ENSEIGNE3);
        db.execSQL(INSERT_ENSEIGNE5);
        db.execSQL(INSERT_ENSEIGNE6);
        db.execSQL(INSERT_ENSEIGNE7);
        db.execSQL(INSERT_ENSEIGNE8);
        db.execSQL(INSERT_ENSEIGNE9);
        db.execSQL(INSERT_ENSEIGNE10);
        db.execSQL(INSERT_ENSEIGNE11);
        db.execSQL(INSERT_ENSEIGNE12);
        db.execSQL(INSERT_ENSEIGNE13);
        db.execSQL(INSERT_ENSEIGNE14);
        db.execSQL(INSERT_ENSEIGNE15);
       /* db.execSQL(INSERT_ENSEIGNE16);
        db.execSQL(INSERT_ENSEIGNE17);
        db.execSQL(INSERT_ENSEIGNE18);
        db.execSQL(INSERT_ENSEIGNE19);
        db.execSQL(INSERT_ENSEIGNE20);
        db.execSQL(INSERT_ENSEIGNE21);
        db.execSQL(INSERT_ENSEIGNE22);
        db.execSQL(INSERT_ENSEIGNE23);
        db.execSQL(INSERT_ENSEIGNE24);
        db.execSQL(INSERT_ENSEIGNE25);
        db.execSQL(INSERT_ENSEIGNE26);
        db.execSQL(INSERT_ENSEIGNE27);
        db.execSQL(INSERT_ENSEIGNE28);
        db.execSQL(INSERT_ENSEIGNE29);
        db.execSQL(INSERT_ENSEIGNE30);
        db.execSQL(INSERT_ENSEIGNE31);*/

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL(DROP_TABLE_ENSEIGNE);
        db.execSQL(DROP_TABLE_PERSONNE);
        db.execSQL(DROP_TABLE_LOCALISATION);
        db.execSQL(DROP_TABLE_COMMENTAIRE);
        db.execSQL(DROP_TABLE_MESSAGE);
        db.execSQL(DROP_TABLE_NOTE);
        db.execSQL(DROP_TABLE_LANGUE);
        db.execSQL(DROP_TABLE_TYPE_ETAB);
        db.execSQL(DROP_TABLE_FAVORIS_E);
        db.execSQL(DROP_TABLE_FAVORIS_P);
        db.execSQL(DROP_TABLE_LANGUE_ENSEIGNE);
        db.execSQL(DROP_TABLE_LANGUE_PERSONNE);
        db.execSQL(DROP_TABLE_EVENEMENT);
        db.execSQL(DROP_TABLE_INVITE);
        onCreate(db);
        //To change body of implemented methods use File | Settings | File Templates.
    }

}
